package com.ctvit.sms.platform.domain;
import com.ctvit.framework.domain.BaseBean;
/**
* domain类
* 对应查询语句
SELECT
         p.z_perno,
             p.z_perna,
             p.z_name_pinyin_first,
             p.z_name_pinyin,
             p.z_telph,
             p.z_mobph,
             p.z_email,
             p.z_dept,
             d.z_dept_nm,
             p.z_type
     FROM
         t_person AS p
     LEFT JOIN t_dept AS d ON p.z_dept = d.z_dept_id
     WHERE
 z_type = '0'  AND p.z_perna LIKE '%p%'
     ORDER BY p.z_name_pinyin ASC
* 
*/ 
public class PersonWithDept extends BaseBean{
	/*
	* 字段:     z_perno 
	* 数据库类型:VARCHAR 
	* 说明:     null
	* 
	*/
	private String zPerno;
	/*
	* 字段:     z_perna 
	* 数据库类型:VARCHAR 
	* 说明:     null
	* 
	*/
	private String zPerna;
	/*
	* 字段:     z_name_pinyin_first 
	* 数据库类型:VARCHAR 
	* 说明:     null
	* 
	*/
	private String zNamePinyinFirst;
	/*
	* 字段:     z_name_pinyin 
	* 数据库类型:VARCHAR 
	* 说明:     null
	* 
	*/
	private String zNamePinyin;
	/*
	* 字段:     z_telph 
	* 数据库类型:VARCHAR 
	* 说明:     null
	* 
	*/
	private String zTelph;
	/*
	* 字段:     z_mobph 
	* 数据库类型:VARCHAR 
	* 说明:     null
	* 
	*/
	private String zMobph;
	/*
	* 字段:     z_email 
	* 数据库类型:VARCHAR 
	* 说明:     null
	* 
	*/
	private String zEmail;
	/*
	* 字段:     z_dept 
	* 数据库类型:VARCHAR 
	* 说明:     null
	* 
	*/
	private String zDept;
	/*
	* 字段:     z_dept_nm 
	* 数据库类型:VARCHAR 
	* 说明:     null
	* 
	*/
	private String zDeptNm;
	/*
	* 字段:     z_type
	* 数据库类型:VARCHAR
	* 说明:     人员类型
				A 管理员
				B 系统帐户
				0 台内人员
				1 群组添加的台外人员
	*
	*/
	private String zType;
	/**
	 * null.
	 *
	 * @return ZPerno type:String
	 */
	public String getZPerno() {
		return zPerno;
	}
	
	/**
	 * null.
	 *
	 * @param newvalue
	 */
	public void setZPerno(String newvalue) {
		this.zPerno = newvalue;
	}
	
	/**
	 * null.
	 *
	 * @return ZPerna type:String
	 */
	public String getZPerna() {
		return zPerna;
	}
	
	/**
	 * null.
	 *
	 * @param newvalue
	 */
	public void setZPerna(String newvalue) {
		this.zPerna = newvalue;
	}
	
	/**
	 * null.
	 *
	 * @return ZNamePinyinFirst type:String
	 */
	public String getZNamePinyinFirst() {
		return zNamePinyinFirst;
	}
	
	/**
	 * null.
	 *
	 * @param newvalue
	 */
	public void setZNamePinyinFirst(String newvalue) {
		this.zNamePinyinFirst = newvalue;
	}
	
	/**
	 * null.
	 *
	 * @return ZNamePinyin type:String
	 */
	public String getZNamePinyin() {
		return zNamePinyin;
	}
	
	/**
	 * null.
	 *
	 * @param newvalue
	 */
	public void setZNamePinyin(String newvalue) {
		this.zNamePinyin = newvalue;
	}
	
	/**
	 * null.
	 *
	 * @return ZTelph type:String
	 */
	public String getZTelph() {
		return zTelph;
	}
	
	/**
	 * null.
	 *
	 * @param newvalue
	 */
	public void setZTelph(String newvalue) {
		this.zTelph = newvalue;
	}
	
	/**
	 * null.
	 *
	 * @return ZMobph type:String
	 */
	public String getZMobph() {
		return zMobph;
	}
	
	/**
	 * null.
	 *
	 * @param newvalue
	 */
	public void setZMobph(String newvalue) {
		this.zMobph = newvalue;
	}
	
	/**
	 * null.
	 *
	 * @return ZEmail type:String
	 */
	public String getZEmail() {
		return zEmail;
	}
	
	/**
	 * null.
	 *
	 * @param newvalue
	 */
	public void setZEmail(String newvalue) {
		this.zEmail = newvalue;
	}
	
	/**
	 * null.
	 *
	 * @return ZDept type:String
	 */
	public String getZDept() {
		return zDept;
	}
	
	/**
	 * null.
	 *
	 * @param newvalue
	 */
	public void setZDept(String newvalue) {
		this.zDept = newvalue;
	}
	
	/**
	 * null.
	 *
	 * @return ZDeptNm type:String
	 */
	public String getZDeptNm() {
		return zDeptNm;
	}
	
	/**
	 * null.
	 *
	 * @param newvalue
	 */
	public void setZDeptNm(String newvalue) {
		this.zDeptNm = newvalue;
	}

	/**
	 * null.
	 *
	 * @return zType type:String
	 */
	public String getzType() {
		return zType;
	}

	/**
	 * null.
	 *
	 * @param newvalue
	 */
	public void setzType(String newvalue) {
		this.zType = newvalue;
	}

}

